Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MSSQL Tutorial
1) Aggregate Functions
2) Analytical Functions
3) CLR
4) Constraints
5) Cursor
6) Data Convert Functions
7) Data Types
8) Database
9) Date Functions
10) Index
11) Insert Delete Update
12) Math Functions
13) Procedure Function
14) Query
15) Sequence Indentity
16) Set Operations
17) String Functions
18) Subquery
19) System Functions
20) System Settings
21) System Tables Views
22) Table
23) Table Join
24) Transact SQL
25) Transaction
26) Trigger
27) User Role
28) View
29) XML

Math Functions
1) ABS function returns the absolute value of any number passed to it
2) ACOS Returns as a float data type, the angle in radians that corresponds to the entered cosine, which must have values betw
3) ASIN Returns as a float data type, the angle in radians that corresponds to the entered sine, which must have values betwee
4) ATAN Returns as a float data type, the angle in radians that corresponds to the entered tangent
5) CASE with FLOOR function
6) CEILING function returns the value representing the smallest integer that is greater-than or equal to the input_number
7) Computing the modulus with FLOOR
8) COS Returns a float value that is the cosine of the angle passed in as a parameter
9) COT returns a float value that is the cotangent of the angle passed in as a parameter
10) DEGREES converts a float value, which represents an angle in radians, into the value of this angle in degrees
11) EXP Returns a float, which is the exponential of the float value passed in as a parameter
12) FLOOR returns the value that represents the largest integer that is less-than or equal to the input_number
13) LOG Takes one positive valued parameter, and returns the natural logarithm of this parameter as a float value
14) LOG10 returns the base 10 logarithm of this parameter as a float value
15) MAX(CEILING(price))
16) MIN(FLOOR(price))
17) PI Returns the value of the mathematical constant PI to 16 decimal places
18) POWER returns a number (input_x) raised to the power of a number (input_y)
19) RADIANS Converts a value in degrees to a value in radians
20) RAND Generates a random number between 0 and 1, which is returned as a float
21) RAND Returns random number from 0 to 1
22) Returning the decimal portion using FLOOR
23) ROUND(salary 1 1, 2)
24) Rounding present value to two decimal places
25) Rounds a value to the number of decimal places specified in the second parameter
26) Select ABS(-1 25)
27) Select CEILING (1 25)
28) Select CEILING(-1 25) (Minus)
29) Select FLOOR(1 25)
30) Select FLOOR(-1 25) (minus)
31) Select ISNUMERIC(-1 25)
32) SELECT ISNUMERIC(123)
33) SELECT ISNUMERIC(123ABC)
34) Select ISNUMERIC(2001-09-30)
35) Select ISNUMERIC(SQL Server)
36) SELECT POWER(10,2) Result
37) Select RAND()
38) SELECT RAND(22) Result
39) Select ROUND(12 4999,0)
40) Select ROUND(12 4999,1)
41) Select ROUND(12 4999,-1) (Minus)
42) Select ROUND(12 5,0)
43) Select ROUND(12 5,0,1)
44) SELECT ROUND(3 22245, 3) RoundedNumber
45) SELECT SQRT(100) Result
46) Select SQRT(125 43)
47) Select SQUARE(5 2786)
48) SIGN returns a -1 if the number is negative, +1 if the number is positive, or 0 if the number is 0
49) SIN returns a float value that is the sine of the angle passed in as a parameter
50) Sin, COS and Tan
51) SQRT function returns the square root of a value 0 or greater
52) SQUARE Returns the square of the given number
53) TAN return a float value that is the tangent of the angle passed in as a parameter